package com.extrace.server.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.extrace.server.pojo.Transnode;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created with IntelliJ IDEA.
 * Description:
 * User: 23735
 * Date: 2024-04-24
 * Time: 16:25
 */
public interface TransnodeMapper extends BaseMapper<Transnode>{
    @Select("SELECT * FROM transnode WHERE SUBSTRING(region_code, 1, 4) = #{regionCode}")
    List<Transnode> findListByRegionCode(@Param("regionCode") String regionCode);
}
